Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
ආරක්ෂා | 6 | 13 | 1 | 13.0000 |
පදනම් | 5 | 12 | 1 | 12.0000 |
අනුගමනය | 7 | 11 | 1 | 11.0000 |
ජෛව | 3 | 10 | 1 | 10.0000 |
වෙබ් | 4 | 8 | 1 | 8.0000 |
රැගෙන | 5 | 8 | 1 | 8.0000 |
2008 | 4 | 8 | 1 | 8.0000 |
මීට | 3 | 8 | 1 | 8.0000 |
හඳුනා | 5 | 7 | 1 | 7.0000 |
අපරාධ | 5 | 7 | 1 | 7.0000 |
බුද්ධ | 5 | 7 | 1 | 7.0000 |
රචනා | 4 | 7 | 1 | 7.0000 |
මෙයට | 4 | 13 | 2 | 6.5000 |
කොළඹ | 4 | 12 | 2 | 6.0000 |
තේරුම් | 6 | 6 | 1 | 6.0000 |
18 | 2 | 6 | 1 | 6.0000 |
විග්රහ | 7 | 6 | 1 | 6.0000 |
හදුනා | 5 | 6 | 1 | 6.0000 |
පැතිර | 5 | 6 | 1 | 6.0000 |
පරිසරය | 6 | 6 | 1 | 6.0000 |
Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
ලදී | 3 | 1 | 43 | 0.0233 |
හැක | 3 | 1 | 34 | 0.0294 |
කරයි | 4 | 2 | 57 | 0.0351 |
ඇත | 2 | 4 | 113 | 0.0354 |
වෙයි | 4 | 1 | 28 | 0.0357 |
කළේය | 4 | 1 | 27 | 0.0370 |
හැකිය | 5 | 1 | 27 | 0.0370 |
කෙරේ | 4 | 1 | 20 | 0.0500 |
වේ | 2 | 6 | 114 | 0.0526 |
ලබයි | 4 | 1 | 19 | 0.0526 |
බවයි | 4 | 1 | 18 | 0.0556 |
ගනී | 3 | 1 | 17 | 0.0588 |
ලදි | 3 | 1 | 15 | 0.0667 |
ලැබේ | 4 | 2 | 25 | 0.0800 |
ලද්දේ | 5 | 1 | 12 | 0.0833 |
පවතී | 4 | 2 | 24 | 0.0833 |
නැත | 3 | 1 | 11 | 0.0909 |
ගත්තේය | 6 | 1 | 11 | 0.0909 |
කළහ | 3 | 1 | 11 | 0.0909 |
තිබේ | 4 | 2 | 21 | 0.0952 |
In this subsection, we compute the ratio of the number of right neighbors and the number of left neighbors. Again, we look for words with extreme ratios:
Data for first table:
select word,w.freq,aa.cnt, bb.cnt,aa.cnt/bb.cnt as r from words w, (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where w_id=aa.w1_id and aa.w1_id=bb.w2_id order by r desc limit 20;
Diagram data:
select aa.cnt, bb.cnt from (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where aa.w1_id=bb.w2_id;
5.1.7.1 Number of NN co-occurrences vs. Frequency I
5.1.7.2 Number of NN co-occurrences vs. Frequency II